﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using System.Web.DynamicData;
using System.ComponentModel;

namespace sistemaAcademicoFinanceiroEscolas.matriculasList
{
    public partial class List : System.Web.UI.Page
    {
        protected MetaTable table;

        protected void Page_Init(object sender, EventArgs e)
        {
            DynamicDataManager1.RegisterControl(GridView1, true /*setSelectionFromUrl*/);
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            table = GridDataSource.GetTable();
            Title = table.DisplayName;



            //InsertHyperLink.NavigateUrl = table.GetActionPath(PageAction.Insert);

            // Disable various options if the table is readonly
            if (table.IsReadOnly)
            {
                GridView1.Columns[0].Visible = false;
                //InsertHyperLink.Visible = false;
            }

            //TxtNome.Focus();
        }

        protected void OnFilterSelectedIndexChanged(object sender, EventArgs e)
        {
            GridView1.PageIndex = 0;
        }

        protected void RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                //sistemaAcademicoFinanceiroEscolas.matricula dc = (sistemaAcademicoFinanceiroEscolas.matricula)e.Row.DataItem;

                //string codigoMatricula = dc.codigoMatricula.ToString();
                  //select para localizar as matriculas cadastradas
                 // OBS select dentro da string.
                string car = "SELECT disciplinaMatricula.codigoDisciplinaMatricula, disciplinaMatricula.codigoDisciplina,disciplinaMatricula.codigoMatricula,disciplina.descricaoDisciplina,disciplina.codigoDisciplina AS Expr1 FROM disciplinaMatricula INNER JOIN disciplina ON disciplinaMatricula.codigoDisciplina = disciplina.codigoDisciplina";
                //car = car + " where disciplinaMatricula.codigoMatricula = " + codigoMatricula;


                System.Data.SqlClient.SqlConnection sqlcar = new System.Data.SqlClient.SqlConnection(ConfigurationManager.AppSettings["baseDados"]);
                sqlcar.Open();

                System.Data.SqlClient.SqlCommand cmdDisciplina = new System.Data.SqlClient.SqlCommand(car, sqlcar);

                System.Data.SqlClient.SqlDataReader myReaderdisciplinaMatricula = cmdDisciplina.ExecuteReader();

                while (myReaderdisciplinaMatricula.Read())
                {
                    string literal = myReaderdisciplinaMatricula["descricaoDisciplina"].ToString() + "<br>";
                    e.Row.Cells[8].Controls.Add(new LiteralControl(literal)); //row Cells,numeração dos campos onde vão receber os dados.

                }


                cmdDisciplina.Dispose();
                myReaderdisciplinaMatricula.Close();
                sqlcar.Close();

            }

        }
    }

}

